{% extends "trees/base.html" %}
{% block title %}Reports - JM3{% endblock %}
{% block content %}
<div class="d-flex justify-content-between align-items-center mb-3">
  <h2 class="mb-0">Reports &amp; Intelligence</h2>
  <a href="{% url 'report_csv' %}" class="btn btn-jm3">⬇ Export CSV</a>
</div>

<div class="row g-3">
  <div class="col-lg-4">
    <div class="card shadow-sm h-100">
      <div class="card-header">Nursery Performance</div>
      <table class="table mb-0">
        <thead><tr><th>Nursery</th><th>Trees</th><th>Survival</th></tr></thead>
        <tbody>
        {% for n in nurseries %}
          <tr><td>{{ n.name }}</td><td>{{ n.sourced_trees }}</td>
            <td>{% if n.verified_survival_rate is not None %}{{ n.verified_survival_rate }}%{% else %}—{% endif %}</td></tr>
        {% empty %}<tr><td colspan="3" class="text-muted">No nurseries.</td></tr>{% endfor %}
        </tbody>
      </table>
    </div>
  </div>
  <div class="col-lg-4">
    <div class="card shadow-sm h-100">
      <div class="card-header">Species Performance</div>
      <table class="table mb-0">
        <thead><tr><th>Species</th><th>Trees</th><th>Survival</th></tr></thead>
        <tbody>
        {% for s in by_species %}
          <tr><td>{{ s.species__common_name }}</td><td>{{ s.total }}</td><td>{% widthratio s.alive s.total 100 %}%</td></tr>
        {% empty %}<tr><td colspan="3" class="text-muted">No data.</td></tr>{% endfor %}
        </tbody>
      </table>
    </div>
  </div>
</div>

<p class="text-muted mt-3 small">PDF / Excel / ESG &amp; donor report templates are the next milestone.</p>
{% endblock %}